This is an excel template for a 4-month project schedule (gantt chart) which can avoid holidays automatically.

You input the holidays, durations and start dates. The end dates will be generated automatically with shaded vertical bars for holidays and colored horizontal task bars avoiding the holidays. If a task with 3 days of duration meets 2 holidays, the task bar will extend to 5 calendar days.

A free trial version can be downloaded from the link below, via Google drive. If you want to use it for a year (US$5), contact me.

Download Now

My email address: stkggo@gmail.com